<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<%
	   int t=0; 
	   String stuId = request.getParameter("stuId");
       String classId = request.getParameter("classId");
       String stuName = new String(request.getParameter("stuName").getBytes("ISO-8859-1"),"UTF-8");
       String stuSex = new String(request.getParameter("stuSex").getBytes("ISO-8859-1"),"UTF-8");
       String stuPwd = request.getParameter("stuPwd");
       try{
       	   Class.forName("com.mysql.jdbc.Driver").newInstance();
       	   Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/classfee", "root", "1234");
       	   Statement stmt = con.createStatement();
       	   ResultSet srt = stmt.executeQuery("SELECT stuId FROM  tb_student where stuId='"+stuId+"'");
       	   while(srt.next())
       	   {
       		   if(srt.getString("stuId").equals(stuId))
       		   {
       			   t=1;
       			   break;
       		   }
       	   }
       	   if(t==1)
       		out.println("<script>alert('该学号已注册!');window.location='studentadd1.jsp'</script>");
       	   else{
    	       stmt.executeUpdate("insert into tb_check(stuId,classId,stuName,stuSex,stupwd) values('"+stuId+"','"+classId+"','" +stuName+"','"+stuSex+"','"+stuPwd+"')");
    	       out.println("<script>alert('信息添加成功,等待管理员审核!');window.location='../stuLogin.html'</script>");
       	   }
       	   srt.close();
       	   stmt.close();
	       con.close();
         }
      catch(Exception ex)
      { 
    	   out.println("<script>alert('注册失败!')</script>");
    	   out.println(ex.getMessage());
      }
	       
%>